MacWorld 1998 February

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1998 February / Macworld (1998-02).dmg / Inside Macworld / FileMaker Pro 4 / FM4 Templates w⁄data / Business / Expenses System / Employee Expenses (.txt) next >

Wrap

FileMaker Pro Database | 1997-09-14 | 172KB | 1,194 lines

nz.soc! s215 0 nz.soc.green! s678 1 nz.test! s1024 0 nz.wanted! s4461 0 oar.noc! s1029 1 oar.tech! s762 0 oar.users! s36 1 oau.biz! s68 0 oau.config! s33 1 oau.forsale! s186 1 oau.news! s3329 0 oau.test! s31 0 oc.acm! s46 0 oc.eats! s12 0 oc.forsale! s1882 0 oc.general! s2865 0 oc.slug! s162 0 oc.test! s305 0 oc.wanted! s304 1 ogi.general! s213 1 oh.biz! s282 1 oh.cast! s494 0 oh.chem! s55 1 oh.forsale! s1045 1 oh.general! s4934 0 oh.jobs! s763 1 oh.k12! s406 0 HBAM2016AUG95 Pro 3.0 HBAM3016AUG95@ demoA filesA filesA launchB planB launchB shippingC shipping systemC systemC consultantsB expoA office supplies joseA seminar shipping systemC joseA launchB lineB marketingB materialsB officeA productB seminarC shippingC suppliesA systemC withB workB marketing consultants materials launch HP DeskJet 540 Printer Pro 3.0 - 4.0 AMOUNT REIMB APPROVED BY CHECK NUMBER CREATED BY DATE 1 DATE 2 DATE 3 DATE 4 DATE 5 DATE 6 DATE 7 DATE APPROVED DATE CREATED DATE EMP SIGNED DATE MODIFIED DATE OF END OF WEEK DATE REIMBURSED EMPLOYEE ID EXPENSE REPORT ID FIRST NAME j FULL NAME GRAND TOTAL LAST LAYOUT g LAST NAME MILE 1 MILE 2 MILE 3 MILE 4 MILE 5 MILE 6 MILE 7 MILE DOLLARS 1 MILE DOLLARS 2 MILE DOLLARS 3 MILE DOLLARS 4 MILE DOLLARS 5 MILE DOLLARS 6 MILE DOLLARS 7 PROJECT PURPOSE OF TRIP RATE PER MILE SUBTOTAL 1 SUBTOTAL 2 SUBTOTAL 3 SUBTOTAL 4 SUBTOTAL 5 SUBTOTAL 6 SUBTOTAL 7 TOTAL MILE AMOUNT TOTAL MILES Pro 2.0 - 2.1F! Pro 3.0 - 4.0 Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7/29/975 Form View - Expenses A List View Expense Report Information Report Menu Form View - Payment Form View - ExpensesB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Expense Report IDB Date CreatedB Date ModifiedB Date 1B 3 - 6 Date 2B 3 - 5 Date 3B 3 - 4 Date 4B 3 - 3 Date 5B 3 - 2 Date of End of WeekB XoThe end of the week usually falls on a Saturday. Are you sure you want to use this date as the end of the week? 1995)) Date 6B 3 - 1 Employee IDB Subtotal 1B 5) + Subtotal 2B 6) + Subtotal 3B 7) + Subtotal 4B 8) + Subtotal 5B 9) + Subtotal 6B ;) + Subtotal 7B <) + Grand TotalB Q) + Rate per MileB Mile 1B Mile 2B Mile 3B Mile 4B Mile 5B Mile 6 Mile 7B Date 7B Mile Dollars 1B Mile Dollars 2B Mile Dollars 3B Mile Dollars 4B Mile Dollars 5B Mile Dollars 6B Mile Dollars 7B Total Mile AmountB ProjectB Purpose of TripB Created ByB Date ReimbursedB Amount ReimbB Date Emp SignedB Approved ByB Date ApprovedB InfoB Total MilesB Last LayoutB Check NumberB First NameB kA Last NameB lA Full NameB Description This expense-tracking database file is a standard business form for reporting reimbursable business expenses. How to use this solution Your employees can enter information directly into the database. Or, they can create a new, blank record, print it, and complete the form by hand. The Report layout has an area for required signatures. How to customize this solution Enter your company's per mile reimbursement rate. To do this, choose Define Fields from the File menu, and doubBOle-click the Rate per Mile field. Then, change the value in the Data text box. A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Totals Miles Purpose of Trip Project | Rate/Mile Week End Emp. ID Report ID Enter data for Employee Expenses Mile Dollars Employee Payment Expenses Employee Expenses Line Items File... Employees File... Total Expense ReportB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Amount` Reimb.a Totalb Weeke Report IDf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo Amount` Reimb.a Totalb Weeke Report IDf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo p3Click to see more information for an Expense Report Emp. IDt Employee InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Rev. 10/6/95 z<Please return completed form to accounts payable department. Manager Signature Employee Signature Date Reimbursed Amount Reimbursed Totals: Miles:tment. Manager Signature Employee Signature Date Reimbursed Amount Reimbursed Totals: Miles: Totals Dates: Rate/Mile Purpose of Trip Project Department Phone/Extension Emp. ID Week Ending Report ID Company Name and Logo Employee Expense Report Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO0Information about the Employee Expenses solutionP Info for this Solution ut the Employee Expenses solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Expense ReportE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Form View - PaymentB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Amount Date Reimbursed Purpose of Trip Project Week End Emp. ID Report ID /Enter Payment information for Employee Expenses Employee Payment Expenses Employee Expenses Line Items File... Employees File... Total Approved By Date Signed Date Approved Check Number File... Total Approved By Date Signed Date Approved Check Number 05/09/95Y 10/6/95n 7/30/95o 7/31/95p 8/1/95q 8/2/95r 8/3/95s 8/5/95t 8/4/95} 8/5/95 Demo Files ]&Go to Office Supplies Expo in San Jose Paul Farrah 9/1/95 1414.55 8/7/95 8/7/95 13156 05/09/95Y 10/6/95n 10/1/95o 10/2/95p 10/3/95q 10/4/95r 10/5/95s 10/7/95t 10/6/95} 10/7/95 Plan Launch ]LWork with marketing consultants on materials for launch of new product line. Paul Farrah 10/6/95 05/09/95Y 10/6/95n 7/16/95o 7/17/95p 7/18/95q 7/19/95r 7/20/95s 7/22/95t 7/21/95} 7/22/95 Shipping System ]%Go to seminar on new shipping system. Paul Farrah 7/21/95 Your Own ButtonB ReportsC View As ListD View As FormE CloseF Helvetica Geneva Times Times New Roman Arial MS Sans Serif UETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Sort by Last Name Sort by Date of End of Week Open Script )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request. Open Expense Line Items File Open Employee Names File Information A List View Report Menu Shutdown Script HP DeskJet 540 Printer Open Employee Names File Open Expense Line Items File Information List View Report Menu Sort by Expense Report ID Sort by Last Name Sort by Date of End of Week Expense Report Open Script Shutdown Script Sort by Expense Report ID Expense Report wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! Ejwwg wwxwwxw wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww ;NAME FPTHA;HARDDISK:CONSULT:ClarisII:v3:qafirst:Expense Line Items.fp3 NAMEA Expense Line Items.fp3 RPTHA Expense Line Items.fp3 SRPTA exp_itms.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ 7NAME FPTHA7HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee Names.fp3 NAMEA Employee Names.fp3 RPTHA Employee Names.fp3 SRPTA emp_name.fp3 WSPCA C:\CONSULT\ClarisII\v3\qafirst\ bRPTH FPTHAbGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Names MSPCA NAMEA Employee Names RPTHA Employee Names alisBanquet Meals Business Meals Entertainment VDEFA( Names wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 AD@D@ AD@D@ 44444 CCCCC 44444 CCCCC $42" alisA FPTH@ @@BA@ bRBBP0 UUUUU JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! (*)(%,3& )%+@6) ",30,)% UUUUUU wwwwww #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0% &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww (LIST VDEFA( (LIST VDEFA( Expense Type ListB Project ListC Employee List FMRLA FMRLA Expense Line ItemsB Employee Names Description This expense-tracking database file is a standard business form for reporting reimbursable business expenses. How to use this solution Your employees can enter information directly into the database. Or, they can create a new, blank record, print it, and complete the form by hand. The Report layout has an area for required signatures. How to customize this solution Enter your company's per mile reimbursement rate. To do this, choose Define Fields from the File menu, and doubBOle-click the Rate per Mile field. Then, change the value in the Data text box. fRPTH plates:Business:Expenses System:Expense Line Items MSPCA NAMEA Expense Line Items RPTHA Expense Line Items Grendal Expense Line Items FMP3FMP3 Expenses System fGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items SCW-InfoMgmt Kevster (7100/66) Grendal Kevin Jundt (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment VDEFA( Grendal Employee Names FMP3FMP3 Expenses System bGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Names SCW-InfoMgmt Kevster (7100/66) Grendal Kevin Jundt FPTHAfGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items MSPCA NAMEA Expense Line Items RPTHA Expense Line Items Grendal Expense Line Items FMP3FMP3 Expenses System fGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items SCW-InfoMgmt Kevster (7100/66) Grendal Kevin Jundt (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment VDEFA( Employee Expense Report